package dao;

import util.DBHelper;

import java.util.List;
import java.util.Map;

public class NewProductRecommendDao {
    public List<Map<String,Object>> getImage(){
        String sql = " select p.proid,SUM(quantity) as quantity,p.price ,p.proname,image from shopping_product p  LEFT JOIN   orderdetail o on o.proid = p.proid GROUP BY p.proid ";
        return DBHelper.selectListMap(sql);
    }
}
